<HTML><HEAD><meta http-equiv="content-type" content="text/html; charset=utf-8"><meta http-equiv="imagetoolbar" content="no"></HEAD><BODY>
<DIV id=u0 style="position:absolute; left:10px; top:35px; width:840px; height:1px; BORDER-TOP:solid 1px #000000; ;">
</DIV>

<DIV id=u1 style="position:absolute; left:10px; top:10px; width:30px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>首页</u></span></DIV>
</DIV>
<DIV id=u2 style="position:absolute; left:50px; top:10px; width:60px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>我的收藏</u></span></DIV>
</DIV>
<DIV id=u3 style="position:absolute; left:114px; top:10px; width:66px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>个人设置</u></span></DIV>
</DIV>
<DIV id=u4 style="position:absolute; left:179px; top:10px; width:66px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>添加新收藏</u></span></DIV>
</DIV>
<DIV id=u5 style="position:absolute; left:720px; top:13px; width:30px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>注册</u></span></DIV>
</DIV>
<DIV id=u6 style="position:absolute; left:761px; top:13px; width:30px; height:17px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;"><u>登录</u></span></DIV>
</DIV>
<DIV id=u7 style="position:absolute; left:30px; top:74px; width:50px; height:16px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">URL</span></DIV>
</DIV>
<DIV id=u8 style="position:absolute; left:30px; top:110px; width:50px; height:16px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">Note</span></DIV>
</DIV>
<DIV id=u9 style="position:absolute; left:30px; top:150px; width:70px; height:16px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">Description</span></DIV>
</DIV>
<DIV id=u10 style="position:absolute; left:30px; top:270px; width:50px; height:16px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">Tag</span></DIV>
</DIV>
<INPUT id=u11  type=text value="" style="position:absolute; left:100px; top:70px; width:370px; height:25px; ; background-color:#FFFFFF; text-align: left ; font-family:'Arial'; font-size: 10pt; color:#000000; font-style:normal; font-weight:normal; text-decoration:none">

<INPUT id=u12  type=text value="" style="position:absolute; left:100px; top:110px; width:370px; height:25px; ; background-color:#FFFFFF; text-align: left ; font-family:'Arial'; font-size: 10pt; color:#000000; font-style:normal; font-weight:normal; text-decoration:none">

<TEXTAREA id=u13  style="position:absolute; left:100px; top:155px; width:370px; height:95px; ; background-color:#FFFFFF; text-align: left ; font-family:'Courier New'; font-size: 10pt; color:#000000; font-style:normal; font-weight:normal; text-decoration:none"></TEXTAREA>

<INPUT id=u14  type=text value="" style="position:absolute; left:105px; top:270px; width:365px; height:25px; ; background-color:#FFFFFF; text-align: left ; font-family:'Arial'; font-size: 10pt; color:#000000; font-style:normal; font-weight:normal; text-decoration:none">

<INPUT id=u15  type=submit value="收藏" style="position:absolute; left:30px; top:320px; width:100px; height:25px; ; ; text-align: center ; font-family:'Arial'; font-size: 10pt; color:#000000; font-style:normal; font-weight:normal; text-decoration:none">

<DIV id=u16 style="position:absolute; left:510px; top:70px; width:330px; height:288px; ; ; text-align: left ; font-family:Arial; text-align:left;">
<DIV><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">说明:点击收藏后发生的事情:<br>1. 根据</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">url</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">查找</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">表中是否存在,如果存在则<br>在</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">users_urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">表中添加一条记录,同时更新</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">中该记录的</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">last_collected_at,last_collected_user,<br>note,description</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">字段;<br>如果</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">url</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">不存在,首先要在</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">中添加一条</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">url</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">记录,再在</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">users_urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">关系表中添加一条关系<br><br>2. 检索</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">Tags</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">表,对于不存在的</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">tag</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">进行添加,同时将新的</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">user,url,tag</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">关系添加到</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">taggings</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">表中<br><br>比如收藏了</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">google.com</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">这个</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">url</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">(标签是</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">google, web2.0</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">)后</span><br><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">中会有</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">google.com</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">这条记录</span><br><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">users_urls</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">会有收藏的用户</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">id</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">和</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">url_id</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">这样一条记录</span><br><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">tags</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">中会有</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">google,web2.0</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">两条记录</span><br><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">taggings</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">中会有</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">user_id,url_id,tag_id(</span><span style=" font-family:'\'cb\'ce\'cc\'e5'; color:#000000; font-size:10pt;">共两条记录</span><span style=" font-family:'Arial'; color:#000000; font-size:10pt;">)</span></DIV>
</DIV><SCRIPT src="Resources/axurerp_pagescript.js"></SCRIPT>
<SCRIPT src="url_files/axurerp_pagespecificscript.js"></SCRIPT></BODY></HTML>